<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.8"/>
<title>embedme: libemb/inc/SqliteWrapper.h 源文件</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="logo.png"/></td>
  <td style="padding-left: 0.5em;">
   <div id="projectname">embedme
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- 制作者 Doxygen 1.8.8 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>首页</span></a></li>
      <li><a href="annotated.html"><span>类</span></a></li>
      <li class="current"><a href="files.html"><span>文件</span></a></li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>文件列表</span></a></li>
      <li><a href="globals.html"><span>文件成员</span></a></li>
    </ul>
  </div>
<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_574d9269cd334a9d02d8928365303d98.html">libemb</a></li><li class="navelem"><a class="el" href="dir_207aad82934689048a9003fb51f06f7f.html">inc</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">SqliteWrapper.h</div>  </div>
</div><!--header-->
<div class="contents">
<a href="_sqlite_wrapper_8h.html">浏览该文件的文档.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="comment">/******************************************************************************</span></div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment"> * This file is part of libemb.</span></div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> * libemb is free software: you can redistribute it and/or modify</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> * it under the terms of the GNU General Public License as published by</span></div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> * the Free Software Foundation, either version 3 of the License, or</span></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment"> * (at your option) any later version.</span></div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment"> * libemb is distributed in the hope that it will be useful,</span></div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment"> * but WITHOUT ANY WARRANTY; without even the implied warranty of</span></div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment"> * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the</span></div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment"> * GNU General Public License for more details.</span></div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment"> * You should have received a copy of the GNU General Public License</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment"> * along with libemb.  If not, see &lt;http://www.gnu.org/licenses/&gt;.</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment"> *</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment"> * Project: Embedme</span></div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="comment"> * Author : FergusZeng</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="comment"> * Email  : cblock@126.com</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="comment"> * git    : https://git.oschina.net/cblock/embedme</span></div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="comment"> * Copyright 2014 @ ShenZhen ,China</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="comment">*******************************************************************************/</span></div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="preprocessor">#ifndef __SQLITEWRAPPER_H__</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="preprocessor">#define __SQLITEWRAPPER_H__</span></div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;</div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="preprocessor">#ifdef OS_NONUNIX</span></div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="preprocessor">#else</span></div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="preprocessor">#include &quot;sqlite3.h&quot;</span></div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="preprocessor">#include &quot;<a class="code" href="_data_base_8h.html">DataBase.h</a>&quot;</span></div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;<span class="preprocessor">#include &quot;<a class="code" href="_mutex_8h.html">Mutex.h</a>&quot;</span></div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;</div>
<div class="line"><a name="l00037"></a><span class="lineno"><a class="line" href="class_sqlite_wrapper.html">   37</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_sqlite_wrapper.html">SqliteWrapper</a>:<span class="keyword">public</span> <a class="code" href="class_data_base.html">DataBase</a>{</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;<span class="keyword">public</span>:</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;    <a class="code" href="class_sqlite_wrapper.html">SqliteWrapper</a>();</div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;    ~<a class="code" href="class_sqlite_wrapper.html">SqliteWrapper</a>();</div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#a40c6f1a1b1653d32f78e278b38add84f">open</a>(std::string dbName);</div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#ad4c51d552be628cb7cbeb234d1095cc1">connect</a>(std::string user, std::string passwd);</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#afb5508c06124105cbb102539f8da8b94">close</a>();</div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#a72f83af87d07cf115c814d6bb7c7d8c0">exec</a>(<span class="keyword">const</span> std::string&amp; sql, <a class="code" href="struct_sql_result___s.html">SqlResult_S</a>* result=NULL);</div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#aa40cec147c960cc50f6992cca08760ab">insertBlob</a>(<span class="keyword">const</span> std::string&amp; sql,std::string bindVarName,<span class="keywordtype">char</span>* buf, sint32 len);</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;    sint32 <a class="code" href="class_sqlite_wrapper.html#ac45299aabcf122467fa7b91028895c76">selectBlob</a>(<span class="keyword">const</span> std::string&amp; sql,std::string bindVarName,<span class="keywordtype">char</span>* buf, sint32 &amp;len);</div>
<div class="line"><a name="l00047"></a><span class="lineno">   47</span>&#160;<span class="keyword">private</span>:</div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;    sqlite3* m_db;</div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;    <a class="code" href="class_mutex_lock.html">MutexLock</a> m_dbLock;</div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;};</div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;<span class="preprocessor">#endif</span></div>
<div class="ttc" id="class_sqlite_wrapper_html"><div class="ttname"><a href="class_sqlite_wrapper.html">SqliteWrapper</a></div><div class="ttdoc">Sqlite包装器类 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.h:37</div></div>
<div class="ttc" id="class_sqlite_wrapper_html_afb5508c06124105cbb102539f8da8b94"><div class="ttname"><a href="class_sqlite_wrapper.html#afb5508c06124105cbb102539f8da8b94">SqliteWrapper::close</a></div><div class="ttdeci">sint32 close()</div><div class="ttdoc">关闭数据库 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:81</div></div>
<div class="ttc" id="class_sqlite_wrapper_html_a72f83af87d07cf115c814d6bb7c7d8c0"><div class="ttname"><a href="class_sqlite_wrapper.html#a72f83af87d07cf115c814d6bb7c7d8c0">SqliteWrapper::exec</a></div><div class="ttdeci">sint32 exec(const std::string &amp;sql, SqlResult_S *result=NULL)</div><div class="ttdoc">执行SQL语句 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:132</div></div>
<div class="ttc" id="struct_sql_result___s_html"><div class="ttname"><a href="struct_sql_result___s.html">SqlResult_S</a></div><div class="ttdoc">SQL查询结果结构体 </div><div class="ttdef"><b>Definition:</b> DataBase.h:12</div></div>
<div class="ttc" id="class_sqlite_wrapper_html_aa40cec147c960cc50f6992cca08760ab"><div class="ttname"><a href="class_sqlite_wrapper.html#aa40cec147c960cc50f6992cca08760ab">SqliteWrapper::insertBlob</a></div><div class="ttdeci">sint32 insertBlob(const std::string &amp;sql, std::string bindVarName, char *buf, sint32 len)</div><div class="ttdoc">插入二进制数据 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:169</div></div>
<div class="ttc" id="class_data_base_html"><div class="ttname"><a href="class_data_base.html">DataBase</a></div><div class="ttdoc">数据库抽象类. </div><div class="ttdef"><b>Definition:</b> DataBase.h:23</div></div>
<div class="ttc" id="class_mutex_lock_html"><div class="ttname"><a href="class_mutex_lock.html">MutexLock</a></div><div class="ttdoc">互斥锁类 </div><div class="ttdef"><b>Definition:</b> Mutex.h:35</div></div>
<div class="ttc" id="class_sqlite_wrapper_html_ad4c51d552be628cb7cbeb234d1095cc1"><div class="ttname"><a href="class_sqlite_wrapper.html#ad4c51d552be628cb7cbeb234d1095cc1">SqliteWrapper::connect</a></div><div class="ttdeci">sint32 connect(std::string user, std::string passwd)</div><div class="ttdoc">连接数据库 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:71</div></div>
<div class="ttc" id="_mutex_8h_html"><div class="ttname"><a href="_mutex_8h.html">Mutex.h</a></div></div>
<div class="ttc" id="_data_base_8h_html"><div class="ttname"><a href="_data_base_8h.html">DataBase.h</a></div></div>
<div class="ttc" id="class_sqlite_wrapper_html_a40c6f1a1b1653d32f78e278b38add84f"><div class="ttname"><a href="class_sqlite_wrapper.html#a40c6f1a1b1653d32f78e278b38add84f">SqliteWrapper::open</a></div><div class="ttdeci">sint32 open(std::string dbName)</div><div class="ttdoc">打开数据库 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:43</div></div>
<div class="ttc" id="class_sqlite_wrapper_html_ac45299aabcf122467fa7b91028895c76"><div class="ttname"><a href="class_sqlite_wrapper.html#ac45299aabcf122467fa7b91028895c76">SqliteWrapper::selectBlob</a></div><div class="ttdeci">sint32 selectBlob(const std::string &amp;sql, std::string bindVarName, char *buf, sint32 &amp;len)</div><div class="ttdoc">读取二进制数据 </div><div class="ttdef"><b>Definition:</b> SqliteWrapper.cpp:208</div></div>
</div><!-- fragment --></div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
生成于 2016年 七月 7日 星期四 19:49:37 , 为 embedme使用  &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.8
</small></address>
</body>
</html>
